Wanted:

A1, A2, A3, A4,... Z100

But query with sorting (ORDER BY asc)

A1

A10

A11

..

A2

A21

A22

My way to works.

SELECT issue FROM table ORDER BY substr(issue,1,1) ASC, CAST(substr(issue,2) as unsigned) ASC